SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Nanshan Disrtict" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Luohu District" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Futian District" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8
SELECT property.ProName, property.ID, pro_tag.pro_id, pro_tag.tag_id, pro_tag.mins, tags.tag_type, tags.tag_name, tags.tag_value FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id where property.ID in (SELECT property.ID FROM property left join pro_tag on property.id = pro_tag.pro_id left join tags on pro_tag.tag_id = tags.id WHERE tags.tag_name = "Others" ) and tags.tag_name = "Popular" order by property.ProName asc limit 8